﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using DALScolarite;
namespace DALScolarite 
{
    public partial class scolarite_classes
    {
        uvtmoyEntities ent;
        public List<scolarite_classes> classe(string ideltdiplome)
        {
            ent = new uvtmoyEntities();
            var query = (from s in ent.scolarite_classes
                         where !(from s2 in ent.scolarite_inscription where s2.idEltDiplome==ideltdiplome select s2.idEltDiplome).Contains(s.idClasse)
                            
                         select s);
            if (query.Any())
            {

                return query.Distinct().ToList();
            }
            else
            {
                return null;
            }
        }
    }
}
